﻿



CREATE proc [dbo].[GetUser]
@UserID int = 0
as
begin
	select	u.UserID,
			u.Vorname,
			u.Nachname,
			u.LoginName,
			u.[Gesperrt],
			u.[WorkingLevel],
			u.[ValidTo]
	from	[User].datUser u
	where	(u.UserID = @UserID or @UserID = 0)
end

GO
GRANT EXECUTE
    ON OBJECT::[dbo].[GetUser] TO PUBLIC
    AS [dbo];

